package com.cakebackoffice.database;


public class ProductCategoryTable extends DatabaseTable {
    public static final String TABLESNAME = "ProductCategoryTable";
    public static final String ID = "_id";
    public static final String REMOTE_ID = "remoteId";
    public static final String NAME = "name";
    public static final String ILLUSTRATION = "illustration";
    public static final String DESCRIPTION = "description";


    public static final String[] ALLFIELDS = new String[]{
            ID,
            REMOTE_ID,
            NAME,
            ILLUSTRATION,
            DESCRIPTION
    };

    public static final String CREATE = "CREATE TABLE " + TABLESNAME
            + " ( "
            + ID + " INTEGER PRIMARY KEY AUTOINCREMENT , "
            + REMOTE_ID + " INTEGER ,"
            + NAME + " TEXT , "
            + ILLUSTRATION + " TEXT , "
            + DESCRIPTION + " TEXT ); ";

    private static DatabaseTable ourInstance = new ProductCategoryTable();


    @Override
    public String getTableName() {
        return TABLESNAME;
    }

    @Override
    public String[] getAllFields() {
        return ALLFIELDS;
    }

    @Override
    public String getCreate() {
        return CREATE;
    }

    public static DatabaseTable getInstance() {
        return ourInstance;
    }

    private ProductCategoryTable() {
    }
}
